SyCampusGrp

Logical Entity Name | SyCampusGrp
Default Table Name | SyCampusGrp
Physical Only | NO
Owner | dbo
Definition |
Note |

SyCampusGrp Columns

ColumnName | Domain | Datatype | NULL | Definition
SyCampusGrpID |  | int | NO |
Code |  | char(16) | NO |
Descrip |  | varchar(35) | NO |
Userid |  | int | NO |
SystemCode |  | bit | NO |
SaStmtComments |  | varchar(1000) | YES |
SaStmtLastCloseDate |  | datetime | YES |
ModFlag |  | char(1) | NO |
Type |  | char(1) | NO |
Active |  | bit | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
FinancialCampusGroup |  | bit | NO |

SyCampusGrp Primary and Unique Keys

Key Name | Key Type | Keys
SyCampusGrp_Type_SyCampusGRPID_U_N_IDX | Index | Type, SyCampusGrpID
SyCampusGrp_SyCampusGrpID_U_C_IDX | PrimaryKey | SyCampusGrpID

SyCampusGrp Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdStartDate | Non-Identifying | One To Zero or More | FK__AdStartDa__SyCam__241614B4 |  |  |  | NO | YES
AdStartDateCalendar | Non-Identifying | One To Zero or More | FK__AdStartDa__SyCam__250A38ED |  |  |  | NO | YES
AdAttribute | Non-Identifying | One To Zero or More | FK_AdAttribute_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdCatalogYear | Non-Identifying | One To Zero or More | FK_AdCatalogYear_SyCampusGrpId_SyCampusGrp_SyCampusGrpId |  |  |  | NO | YES
AdClassSchedCancelReason | Non-Identifying | One To Zero or More | FK_AdClassSchedCancelReason_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdConcentration | Non-Identifying | One To Zero or More | FK_AdConcentration_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdCourseFulfillmentOrder | Non-Identifying | One To Zero or More | FK_AdCourseFulfillmentOrder_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdCoursePrefix | Non-Identifying | One To Zero or More | FK_AdCoursePrefix_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdCourseStatusChangeReason | Non-Identifying | One To Zero or More | FK_AdCourseStatusChangeReason_SycampusGrpID_SycampusGrp_SycampusGrpID |  |  |  | NO | YES
AdFinalGradeReason | Non-Identifying | One To Zero or More | FK_AdFinalGradeReason_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdGPA | Non-Identifying | One To Zero or More | FK_AdGPASyCampusGrpID_SyCampusGrpSyCampusGrpID |  |  |  | NO | YES
AdLesson | Non-Identifying | One To Zero or More | FK_AdLesson_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdLessonPlan | Non-Identifying | One To Zero or More | FK_AdLessonPlan_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdLocation | Non-Identifying | One To Zero or More | FK_AdLocation_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdProgramTermsInAY | Non-Identifying | One To Zero or More | FK_AdProgramTermsInAYSyCampusGrpID_SyCampusGrpSyCampusGrpID |  |  |  | NO | YES
AdRegistrationGroup | Non-Identifying | One To Zero or More | FK_AdRegistrationGroup_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
AdTermProgramAssociation | Non-Identifying | One To Zero or More | FK_AdTermProgramAssociationSyCampusGrpID_SyCampusGrpSyCampusGrpID |  |  |  | NO | YES
AmApplication | Non-Identifying | One To Zero or More | FK_AmApplication_SyCampusGrpId_SyCampusGrp_SyCampusGrpId |  |  |  | NO | YES
AmExamLocation | Non-Identifying | One To Zero or More | FK_AmExamLocation_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
CmDocMgmtSftDetail | Non-Identifying | One To Zero or More | FK_CmDocMgmtSftDetail_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
faExcusedAbsencePolicy | Non-Identifying | One To Zero or More | FK_faExcusedAbsencePolicy_SyCampusGrpid_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
FaTermAssociationTrack | Non-Identifying | One To Zero or More | FK_FaTermAssociationTrack_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
FaTermAssociationTrackProgramVersion | Non-Identifying | One To Zero or More | FK_FaTermAssociationTrackProgramVersion_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
FaTermTrack | Non-Identifying | One To Zero or More | FK_FaTermTrack_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
HsBuilding | Non-Identifying | One To Zero or More | FK_HsBuilding_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
HsBuildingCategories | Non-Identifying | One To Zero or More | FK_hsBuildingCategories_syCampusGrpID_syCampusGrp_syCampusGrpID |  |  |  | NO | YES
HsHousingDates | Non-Identifying | One To Zero or More | FK_HsHousingDates_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
HsRoomCategories | Non-Identifying | One To Zero or More | FK_hsRoomCategories_syCampusGrpID_syCampusGrp_syCampusGrpID |  |  |  | NO | YES
HsSuiteCategories | Non-Identifying | One To Zero or More | FK_hsSuiteCategories_syCampusGrpID_syCampusGrp_syCampusGrpID |  |  |  | NO | YES
PlAttribute | Non-Identifying | One To Zero or More | FK_PlAttribute.SyCampusGrpID_SyCampusGrp.SyCampusGrpID |  |  |  | NO | YES
PlCertifications | Non-Identifying | One To Zero or More | FK_PlCertifications.SyCampusGrpID_SyCampusGrp.SyCampusGrpID |  |  |  | NO | YES
PlEmployerCareerField | Non-Identifying | One To Zero or More | FK_PLEmployerCareerField_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
PlEmployerContactJobSkill | Non-Identifying | One To Zero or More | FK_PlEmployerContactJobSkill_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
PlEmployerContactSoftSkill | Non-Identifying | One To Zero or More | FK_PlEmployerContactSoftSkill_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
PlEmployerSoftSkill | Non-Identifying | One To Zero or More | FK_PlEmployerSoftSkill_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
PlJobBenefits | Non-Identifying | One To Zero or More | FK_PlJobBenefits.SyCampusGrpID_SyCampusGrp.SyCampusGrpID |  |  |  | NO | YES
SaAcctStatus | Non-Identifying | One To Zero or More | FK_SaAcctStatus_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SaGLBatch | Non-Identifying | One To Zero or More | FK_SaGlBatch_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SaJournalEntryGrp | Non-Identifying | One To Zero or More | FK_SaJournalEntryGrp_SyCampusGrpId_SyCampusGrp_SyCampusGrpId |  |  |  | NO | YES
SaSubsidiary | Non-Identifying | One To Zero or More | FK_SaSubsidiary_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SaTuitionDiscountPolicy | Non-Identifying | One To Zero or More | FK_SaTuitionDiscountPolicy_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SsAthleticStatus | Non-Identifying | One To Zero or More | FK_SsAthleticStatusSyCampusGrpID_SyCampusGrpSyCampusGrpID |  |  |  | NO | YES
SsDisabilityStatus | Non-Identifying | One To Zero or More | FK_SsDisabilityStatusSyCampusGrpID_SyCampusGrpSyCampusGrpID |  |  |  | NO | YES
SsRecruitmentType | Non-Identifying | One To Zero or More | FK_SsRecruitmentTypeSyCampusGrpID_SyCampusGrpSyCampusGrpID |  |  |  | NO | YES
SsRoomType | Non-Identifying | One To Zero or More | FK_SsRoomType_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SsService | Non-Identifying | One To Zero or More | FK_SsService_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SsServiceCategory | Non-Identifying | One To Zero or More | FK_SsServiceCategory_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SsSports | Non-Identifying | One To Zero or More | FK_SsSportsSyCampusGrpID_SyCampusGrpSyCampusGrpID |  |  |  | NO | YES
SyEmpGroups | Non-Identifying | One To Zero or More | FK_SyEmpGroups_SyCampusGrpId_SyCampusGrp_SyCampusGrpId |  |  |  | NO | YES
SyEmpGrp | Non-Identifying | One To Zero or More | FK_SyEmpGrp_SyCampusGrpId_SyCampusGrp_SyCampusGrpId |  |  |  | NO | YES
syIMSConfiguration | Non-Identifying | One To Zero or More | FK_SyIMSConfiguration_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SyIndicator | Non-Identifying | One To Zero or More | FK_SyIndicator_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SyOrganization | Non-Identifying | One To Zero or More | FK_SyOrganization_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SyResidencyStatus | Non-Identifying | Zero or One to Zero or More | FK_SyResidencyStatus_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SyResidencyType | Non-Identifying | Zero or One to Zero or More | FK_SyResidencyType_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SySEVISCampus | Non-Identifying | One To Zero or More | FK_SySEVISCampus_SEVISSyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  |  | NO | YES
SyStaffGroupTemplate | Non-Identifying | One To Zero or More | FK_SyStaffGroupTemplate_SyCampusGrpId_SyCampusGrp_SyCampusGrpId |  |  |  | NO | YES

SyCampusGrp Check Constraints

Check Constraint Name | CheckConstraint

SyCampusGrp Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SyCampusGrp Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.CampusGroup | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyCampusGrp | NO |  |  |

SyCampusGrp Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | SEVIS
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records
Physical (Microsoft SQL Server) | System

SyCampusGrp Data Movement Rules

Name | Type | Rule Text/Value